# INSERT INTO enumerationvalue
# (oid, createTime, editTime, enumerationId, rowIndex, internalName, value_zh_CN, value_en_US, value_ja_JP, description)
# VALUES(37512420856794, '2024-12-19 11:27:44', '2024-12-19 11:28:10', 4052315166530, 21, 'ActValYsj1', 'ActValYsj1', 'ActValYsj1', 'ActValYsj1', NULL);




oid_base = 37512420856898
createTime = '2024-12-19 11:27:44'
editTime = '2024-12-19 11:28:10'
enumerationId = 4052315166530
rowIndex_base = 21
internalName_base = 'ActValWbl'

sql_statements = []

for x in range(2):
    oid = oid_base + x
    rowIndex = rowIndex_base + x
    internalName = f"{internalName_base}{x+1}"
    sql = f"INSERT INTO enumerationvalue (oid, createTime, editTime, enumerationId, rowIndex, internalName, value_zh_CN, value_en_US, value_ja_JP, description) " \
          f"VALUES({oid}, '{createTime}', '{editTime}', {enumerationId}, {rowIndex}, '{internalName}', '{internalName}', '{internalName}', '{internalName}', NULL);"
    sql_statements.append(sql)

# 打印所有生成的SQL语句
for statement in sql_statements:
    print(statement)

